Create Relationship and Create Calendar Table
10
- On
the model window, add a relationship between two table using UserID
- Sometimes Power BI will create relationship between tables automatically, if not you can create the relationship between calendar table and DISC_classScores drag and drop “date” column from Calendar to the DISC_ClassScores.
- Add a Date Calculate table in the Report window, and add a relationship with DISC_ClassScores
https://www.youtube.com/watch?v=-li7sxUxEqA